Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_MVIEW_JOINS

`ALL_MVIEW_JOINS` describes joins between two columns in the `WHERE` clause of the subquery that defines a materialized view accessible to the current user.

Related Views

- `DBA_MVIEW_JOINS` describes all such joins for all materialized views in the database.

- `USER_MVIEW_JOINS` describes such joins for all materialized views owned by the current user.

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as `SYSDATE` or `USER`. These views also exclude materialized views that were created as "snapshots" prior to Oracle8i and that were never altered to enable query rewrite.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the materialized view
`MVIEW_NAME` | `VARCHAR2(30)` | `NOT NULL` | Materialized view name
`DETAILOBJ1_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the first object in the joinFoot 1
`DETAILOBJ1_RELATION` | `VARCHAR2(30)` | `NOT NULL` | Name of the first object in the joinFootref 1
`DETAILOBJ1_COLUMN` | `VARCHAR2(30)` | `NOT NULL` | Join column of the first object in the joinFootref 1
`OPERATOR` | `CHAR(1)` |  | Join operatorFootref 1
`OPERATOR_TYPE` | `VARCHAR2(1)` |  | Whether the join is an inner or outer joinFootref 1
`DETAILOBJ2_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the second object in the joinFootref 1
`DETAILOBJ2_RELATION` | `VARCHAR2(30)` | `NOT NULL` | Name of the second object in the joinFootref 1
`DETAILOBJ2_COLUMN` | `VARCHAR2(30)` | `NOT NULL` | Join column of the second object in the joinFootref 1

Footnote 1 These rows relate only to materialized join views and materialized aggregate views. They describe the two detail objects of a materialized view join.